package com.qdu.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.qdu.entity.CoursePlan;

public interface CoursePlanMapper {
	
	CoursePlan selectCoursePlanById(int id);

	boolean addCoursePlan(@Param("tid") int tid, @Param("bid") int bid, @Param("classrmtype") char classrmtype, @Param("lpid") int lpid);

	boolean modifyCoursePlan(@Param("coursePlan") CoursePlan coursePlan, @Param("tid") int tid, @Param("bid") int bid,
			@Param("lpid") String lpid);

	boolean deleteCoursePlanById(int id);

	CoursePlan selectCoursePlanByThreeId(@Param("bid") int bid, @Param("lpid") int lpid);
	
	List<CoursePlan> selectAllCoursePlan();
	
	List<CoursePlan> selectCoursePlanByTidAndLpid(@Param("tid") String tid, @Param("lpid") int lpid);

	List<CoursePlan> selectCoursePlanByBid(int bid);
}
